package myzzyl.mapper;

import myzzyl.domain.pojo.SysRoleResource;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
* @author 33249
* @description 针对表【sys_role_resource(角色资源关联表)】的数据库操作Mapper
* @createDate 2025-08-20 14:33:41
* @Entity myzzyl.domain.pojo.SysRoleResource
*/
public interface SysRoleResourceMapper extends BaseMapper<SysRoleResource> {

    @Select("select resource_no from sys_role_resource where role_id = #{id}")
    List<String> selectResourceNosByRoleId(Long id);

    @Delete("delete from sys_role_resource where role_id = #{id}")
    void deleteResourceByRole(Long id);

    List<String> selectResourceRequestPathByRoleId(Long id);
}




